﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dbQPDataSet" targetNamespace="http://tempuri.org/dbQPDataSet.xsd" xmlns:mstns="http://tempuri.org/dbQPDataSet.xsd" xmlns="http://tempuri.org/dbQPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DB" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DB (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WpfApp.Properties.Settings.GlobalReference.Default.DB" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BatchesTableAdapter" GeneratorDataComponentClassName="BatchesTableAdapter" Name="Batches" UserDataComponentName="BatchesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Batches" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Batches] WHERE (([ID_Batch] = @Original_ID_Batch) AND ([BatchNumber] = @Original_BatchNumber) AND ([ProductName] = @Original_ProductName) AND ([DateOfManufacture] = @Original_DateOfManufacture) AND ([Quantity] = @Original_Quantity) AND ([TypeOfPackaging] = @Original_TypeOfPackaging) AND ([Unit] = @Original_Unit) AND ((@IsNull_Foreman = 1 AND [Foreman] IS NULL) OR ([Foreman] = @Original_Foreman)) AND ((@IsNull_Analyst = 1 AND [Analyst] IS NULL) OR ([Analyst] = @Original_Analyst)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Batch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BatchNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BatchNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateOfManufacture" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfManufacture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Quantity" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TypeOfPackaging" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfPackaging" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Foreman" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Foreman" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Foreman" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Foreman" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Analyst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Analyst" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Analyst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Analyst" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Batches] ([BatchNumber], [ProductName], [DateOfManufacture], [Quantity], [TypeOfPackaging], [Unit], [Foreman], [Analyst]) VALUES (@BatchNumber, @ProductName, @DateOfManufacture, @Quantity, @TypeOfPackaging, @Unit, @Foreman, @Analyst);
SELECT ID_Batch, BatchNumber, ProductName, DateOfManufacture, Quantity, TypeOfPackaging, Unit, Foreman, Analyst FROM Batches WHERE (ID_Batch = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BatchNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BatchNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateOfManufacture" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfManufacture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Quantity" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TypeOfPackaging" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfPackaging" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Foreman" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Foreman" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Analyst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Analyst" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Batch, BatchNumber, ProductName, DateOfManufacture, Quantity, TypeOfPackaging, Unit, Foreman, Analyst FROM dbo.Batches</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Batches] SET [BatchNumber] = @BatchNumber, [ProductName] = @ProductName, [DateOfManufacture] = @DateOfManufacture, [Quantity] = @Quantity, [TypeOfPackaging] = @TypeOfPackaging, [Unit] = @Unit, [Foreman] = @Foreman, [Analyst] = @Analyst WHERE (([ID_Batch] = @Original_ID_Batch) AND ([BatchNumber] = @Original_BatchNumber) AND ([ProductName] = @Original_ProductName) AND ([DateOfManufacture] = @Original_DateOfManufacture) AND ([Quantity] = @Original_Quantity) AND ([TypeOfPackaging] = @Original_TypeOfPackaging) AND ([Unit] = @Original_Unit) AND ((@IsNull_Foreman = 1 AND [Foreman] IS NULL) OR ([Foreman] = @Original_Foreman)) AND ((@IsNull_Analyst = 1 AND [Analyst] IS NULL) OR ([Analyst] = @Original_Analyst)));
SELECT ID_Batch, BatchNumber, ProductName, DateOfManufacture, Quantity, TypeOfPackaging, Unit, Foreman, Analyst FROM Batches WHERE (ID_Batch = @ID_Batch)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BatchNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BatchNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateOfManufacture" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfManufacture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Quantity" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TypeOfPackaging" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfPackaging" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Foreman" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Foreman" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Analyst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Analyst" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Batch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BatchNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BatchNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateOfManufacture" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateOfManufacture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Quantity" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TypeOfPackaging" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfPackaging" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Foreman" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Foreman" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Foreman" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Foreman" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Analyst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Analyst" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Analyst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Analyst" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Batch" ColumnName="ID_Batch" DataSourceName="dbQP.dbo.Batches" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Batch" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Batch" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Batch" DataSetColumn="ID_Batch" />
              <Mapping SourceColumn="BatchNumber" DataSetColumn="BatchNumber" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="DateOfManufacture" DataSetColumn="DateOfManufacture" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="TypeOfPackaging" DataSetColumn="TypeOfPackaging" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="Foreman" DataSetColumn="Foreman" />
              <Mapping SourceColumn="Analyst" DataSetColumn="Analyst" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeesTableAdapter" GeneratorDataComponentClassName="EmployeesTableAdapter" Name="Employees" UserDataComponentName="EmployeesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Employees" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Employees] WHERE (([ID_Employee] = @Original_ID_Employee) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Employee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Employee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Employees] ([Title], [Name]) VALUES (@Title, @Name);
SELECT ID_Employee, Title, Name FROM Employees WHERE (ID_Employee = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Employee, Title, Name FROM dbo.Employees</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Employees] SET [Title] = @Title, [Name] = @Name WHERE (([ID_Employee] = @Original_ID_Employee) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)));
SELECT ID_Employee, Title, Name FROM Employees WHERE (ID_Employee = @ID_Employee)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Employee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Employee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Employee" ColumnName="ID_Employee" DataSourceName="dbQP.dbo.Employees" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Employee" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Employee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Employee" DataSetColumn="ID_Employee" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ManufacturersTableAdapter" GeneratorDataComponentClassName="ManufacturersTableAdapter" Name="Manufacturers" UserDataComponentName="ManufacturersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Manufacturers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Manufacturers] WHERE (([ID_Taxpayer] = @Original_ID_Taxpayer) AND ([ManufacturerName] = @Original_ManufacturerName) AND ((@IsNull_LegalStatus = 1 AND [LegalStatus] IS NULL) OR ([LegalStatus] = @Original_LegalStatus)) AND ((@IsNull_LegalStatusFull = 1 AND [LegalStatusFull] IS NULL) OR ([LegalStatusFull] = @Original_LegalStatusFull)) AND ([Address] = @Original_Address) AND ((@IsNull_Account = 1 AND [Account] IS NULL) OR ([Account] = @Original_Account)) AND ((@IsNull_Bank = 1 AND [Bank] IS NULL) OR ([Bank] = @Original_Bank)) AND ((@IsNull_BankCode = 1 AND [BankCode] IS NULL) OR ([BankCode] = @Original_BankCode)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Taxpayer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Taxpayer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ManufacturerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ManufacturerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LegalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LegalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LegalStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LegalStatusFull" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LegalStatusFull" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LegalStatusFull" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatusFull" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Account" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Account" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Account" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Account" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bank" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Bank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Manufacturers] ([ID_Taxpayer], [ManufacturerName], [LegalStatus], [LegalStatusFull], [Address], [Account], [Bank], [BankCode]) VALUES (@ID_Taxpayer, @ManufacturerName, @LegalStatus, @LegalStatusFull, @Address, @Account, @Bank, @BankCode);
SELECT ID_Taxpayer, ManufacturerName, LegalStatus, LegalStatusFull, Address, Account, Bank, BankCode FROM Manufacturers WHERE (ID_Taxpayer = @ID_Taxpayer)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Taxpayer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Taxpayer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ManufacturerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ManufacturerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LegalStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LegalStatusFull" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatusFull" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Account" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Account" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Bank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Taxpayer, ManufacturerName, LegalStatus, LegalStatusFull, Address, Account, Bank, BankCode FROM dbo.Manufacturers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Manufacturers] SET [ID_Taxpayer] = @ID_Taxpayer, [ManufacturerName] = @ManufacturerName, [LegalStatus] = @LegalStatus, [LegalStatusFull] = @LegalStatusFull, [Address] = @Address, [Account] = @Account, [Bank] = @Bank, [BankCode] = @BankCode WHERE (([ID_Taxpayer] = @Original_ID_Taxpayer) AND ([ManufacturerName] = @Original_ManufacturerName) AND ((@IsNull_LegalStatus = 1 AND [LegalStatus] IS NULL) OR ([LegalStatus] = @Original_LegalStatus)) AND ((@IsNull_LegalStatusFull = 1 AND [LegalStatusFull] IS NULL) OR ([LegalStatusFull] = @Original_LegalStatusFull)) AND ([Address] = @Original_Address) AND ((@IsNull_Account = 1 AND [Account] IS NULL) OR ([Account] = @Original_Account)) AND ((@IsNull_Bank = 1 AND [Bank] IS NULL) OR ([Bank] = @Original_Bank)) AND ((@IsNull_BankCode = 1 AND [BankCode] IS NULL) OR ([BankCode] = @Original_BankCode)));
SELECT ID_Taxpayer, ManufacturerName, LegalStatus, LegalStatusFull, Address, Account, Bank, BankCode FROM Manufacturers WHERE (ID_Taxpayer = @ID_Taxpayer)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Taxpayer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Taxpayer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ManufacturerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ManufacturerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LegalStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LegalStatusFull" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatusFull" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Account" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Account" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Bank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Taxpayer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Taxpayer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ManufacturerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ManufacturerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LegalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LegalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LegalStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LegalStatusFull" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LegalStatusFull" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LegalStatusFull" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LegalStatusFull" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Account" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Account" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Account" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Account" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bank" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Bank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Taxpayer" DataSetColumn="ID_Taxpayer" />
              <Mapping SourceColumn="ManufacturerName" DataSetColumn="ManufacturerName" />
              <Mapping SourceColumn="LegalStatus" DataSetColumn="LegalStatus" />
              <Mapping SourceColumn="LegalStatusFull" DataSetColumn="LegalStatusFull" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Account" DataSetColumn="Account" />
              <Mapping SourceColumn="Bank" DataSetColumn="Bank" />
              <Mapping SourceColumn="BankCode" DataSetColumn="BankCode" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PackagingTableAdapter" GeneratorDataComponentClassName="PackagingTableAdapter" Name="Packaging" UserDataComponentName="PackagingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Packaging" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Packaging] WHERE (([ID_Packaging] = @Original_ID_Packaging) AND ([PackagingName] = @Original_PackagingName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Packaging" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Packaging" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PackagingName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PackagingName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Packaging] ([PackagingName]) VALUES (@PackagingName);
SELECT ID_Packaging, PackagingName FROM Packaging WHERE (ID_Packaging = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PackagingName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PackagingName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Packaging, PackagingName FROM dbo.Packaging</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Packaging] SET [PackagingName] = @PackagingName WHERE (([ID_Packaging] = @Original_ID_Packaging) AND ([PackagingName] = @Original_PackagingName));
SELECT ID_Packaging, PackagingName FROM Packaging WHERE (ID_Packaging = @ID_Packaging)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PackagingName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PackagingName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Packaging" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Packaging" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PackagingName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PackagingName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Packaging" ColumnName="ID_Packaging" DataSourceName="dbQP.dbo.Packaging" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Packaging" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Packaging" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Packaging" DataSetColumn="ID_Packaging" />
              <Mapping SourceColumn="PackagingName" DataSetColumn="PackagingName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ParametersTableAdapter" GeneratorDataComponentClassName="ParametersTableAdapter" Name="Parameters" UserDataComponentName="ParametersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Parameters" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Parameters] WHERE (([ID_Parameter] = @Original_ID_Parameter) AND ([Parameter] = @Original_Parameter) AND ([Product] = @Original_Product))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Parameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Product" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Parameters] ([Parameter], [Product], [Requirements]) VALUES (@Parameter, @Product, @Requirements);
SELECT ID_Parameter, Parameter, Product, Requirements FROM Parameters WHERE (ID_Parameter = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Product" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Requirements" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Requirements" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Parameter, Parameter, Product, Requirements FROM dbo.Parameters</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Parameters] SET [Parameter] = @Parameter, [Product] = @Product, [Requirements] = @Requirements WHERE (([ID_Parameter] = @Original_ID_Parameter) AND ([Parameter] = @Original_Parameter) AND ([Product] = @Original_Product));
SELECT ID_Parameter, Parameter, Product, Requirements FROM Parameters WHERE (ID_Parameter = @ID_Parameter)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Product" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Requirements" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Requirements" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Parameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Product" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Parameter" ColumnName="ID_Parameter" DataSourceName="dbQP.dbo.Parameters" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Parameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Parameter" DataSetColumn="ID_Parameter" />
              <Mapping SourceColumn="Parameter" DataSetColumn="Parameter" />
              <Mapping SourceColumn="Product" DataSetColumn="Product" />
              <Mapping SourceColumn="Requirements" DataSetColumn="Requirements" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Products] WHERE (([ID_Product] = @Original_ID_Product) AND ([ProductName] = @Original_ProductName) AND ([Manufacturer] = @Original_Manufacturer) AND ([TypeOfProduct] = @Original_TypeOfProduct) AND ([TechnicalStandards] = @Original_TechnicalStandards) AND ([Composition] = @Original_Composition) AND ([ExpirationDate] = @Original_ExpirationDate) AND ([SignOfDanger] = @Original_SignOfDanger))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Product" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TechnicalStandards" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnicalStandards" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Composition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ExpirationDate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SignOfDanger" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SignOfDanger" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Products] ([ProductName], [Manufacturer], [TypeOfProduct], [TechnicalStandards], [Composition], [ExpirationDate], [SignOfDanger], [DangerClass]) VALUES (@ProductName, @Manufacturer, @TypeOfProduct, @TechnicalStandards, @Composition, @ExpirationDate, @SignOfDanger, @DangerClass);
SELECT ID_Product, ProductName, Manufacturer, TypeOfProduct, TechnicalStandards, Composition, ExpirationDate, SignOfDanger, DangerClass FROM Products WHERE (ID_Product = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TechnicalStandards" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnicalStandards" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Composition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExpirationDate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SignOfDanger" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SignOfDanger" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DangerClass" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="DangerClass" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Product, ProductName, Manufacturer, TypeOfProduct, TechnicalStandards, Composition, ExpirationDate, SignOfDanger, DangerClass FROM dbo.Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Products] SET [ProductName] = @ProductName, [Manufacturer] = @Manufacturer, [TypeOfProduct] = @TypeOfProduct, [TechnicalStandards] = @TechnicalStandards, [Composition] = @Composition, [ExpirationDate] = @ExpirationDate, [SignOfDanger] = @SignOfDanger, [DangerClass] = @DangerClass WHERE (([ID_Product] = @Original_ID_Product) AND ([ProductName] = @Original_ProductName) AND ([Manufacturer] = @Original_Manufacturer) AND ([TypeOfProduct] = @Original_TypeOfProduct) AND ([TechnicalStandards] = @Original_TechnicalStandards) AND ([Composition] = @Original_Composition) AND ([ExpirationDate] = @Original_ExpirationDate) AND ([SignOfDanger] = @Original_SignOfDanger));
SELECT ID_Product, ProductName, Manufacturer, TypeOfProduct, TechnicalStandards, Composition, ExpirationDate, SignOfDanger, DangerClass FROM Products WHERE (ID_Product = @ID_Product)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TechnicalStandards" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnicalStandards" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Composition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ExpirationDate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SignOfDanger" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SignOfDanger" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DangerClass" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="DangerClass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Product" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TechnicalStandards" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnicalStandards" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Composition" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ExpirationDate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SignOfDanger" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SignOfDanger" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Product" ColumnName="ID_Product" DataSourceName="dbQP.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Product" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Product" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Product" DataSetColumn="ID_Product" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Manufacturer" DataSetColumn="Manufacturer" />
              <Mapping SourceColumn="TypeOfProduct" DataSetColumn="TypeOfProduct" />
              <Mapping SourceColumn="TechnicalStandards" DataSetColumn="TechnicalStandards" />
              <Mapping SourceColumn="Composition" DataSetColumn="Composition" />
              <Mapping SourceColumn="ExpirationDate" DataSetColumn="ExpirationDate" />
              <Mapping SourceColumn="SignOfDanger" DataSetColumn="SignOfDanger" />
              <Mapping SourceColumn="DangerClass" DataSetColumn="DangerClass" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QualityPassportsTableAdapter" GeneratorDataComponentClassName="QualityPassportsTableAdapter" Name="QualityPassports" UserDataComponentName="QualityPassportsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.QualityPassports" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[QualityPassports] WHERE (([ID_QualityPassport] = @Original_ID_QualityPassport) AND ((@IsNull_Parameter = 1 AND [Parameter] IS NULL) OR ([Parameter] = @Original_Parameter)) AND ((@IsNull_Batch = 1 AND [Batch] IS NULL) OR ([Batch] = @Original_Batch)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_QualityPassport" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_QualityPassport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Batch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Batch" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[QualityPassports] ([Parameter], [MeasurementКesults], [Batch]) VALUES (@Parameter, @MeasurementКesults, @Batch);
SELECT ID_QualityPassport, Parameter, MeasurementКesults, Batch FROM QualityPassports WHERE (ID_QualityPassport = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MeasurementКesults" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MeasurementКesults" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Batch" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_QualityPassport, Parameter, MeasurementКesults, Batch FROM dbo.QualityPassports</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[QualityPassports] SET [Parameter] = @Parameter, [MeasurementКesults] = @MeasurementКesults, [Batch] = @Batch WHERE (([ID_QualityPassport] = @Original_ID_QualityPassport) AND ((@IsNull_Parameter = 1 AND [Parameter] IS NULL) OR ([Parameter] = @Original_Parameter)) AND ((@IsNull_Batch = 1 AND [Batch] IS NULL) OR ([Batch] = @Original_Batch)));
SELECT ID_QualityPassport, Parameter, MeasurementКesults, Batch FROM QualityPassports WHERE (ID_QualityPassport = @ID_QualityPassport)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MeasurementКesults" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MeasurementКesults" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Batch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_QualityPassport" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_QualityPassport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Parameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Parameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Batch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Batch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Batch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_QualityPassport" ColumnName="ID_QualityPassport" DataSourceName="dbQP.dbo.QualityPassports" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_QualityPassport" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_QualityPassport" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_QualityPassport" DataSetColumn="ID_QualityPassport" />
              <Mapping SourceColumn="Parameter" DataSetColumn="Parameter" />
              <Mapping SourceColumn="MeasurementКesults" DataSetColumn="MeasurementКesults" />
              <Mapping SourceColumn="Batch" DataSetColumn="Batch" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypeOfParametersTableAdapter" GeneratorDataComponentClassName="TypeOfParametersTableAdapter" Name="TypeOfParameters" UserDataComponentName="TypeOfParametersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.TypeOfParameters" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TypeOfParameters] WHERE (([ID_TypeOfParameter] = @Original_ID_TypeOfParameter) AND ([TypeOfParameter] = @Original_TypeOfParameter))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_TypeOfParameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeOfParameter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypeOfParameters] ([TypeOfParameter]) VALUES (@TypeOfParameter);
SELECT ID_TypeOfParameter, TypeOfParameter FROM TypeOfParameters WHERE (ID_TypeOfParameter = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeOfParameter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_TypeOfParameter, TypeOfParameter FROM dbo.TypeOfParameters</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypeOfParameters] SET [TypeOfParameter] = @TypeOfParameter WHERE (([ID_TypeOfParameter] = @Original_ID_TypeOfParameter) AND ([TypeOfParameter] = @Original_TypeOfParameter));
SELECT ID_TypeOfParameter, TypeOfParameter FROM TypeOfParameters WHERE (ID_TypeOfParameter = @ID_TypeOfParameter)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeOfParameter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_TypeOfParameter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeOfParameter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_TypeOfParameter" ColumnName="ID_TypeOfParameter" DataSourceName="dbQP.dbo.TypeOfParameters" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_TypeOfParameter" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_TypeOfParameter" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_TypeOfParameter" DataSetColumn="ID_TypeOfParameter" />
              <Mapping SourceColumn="TypeOfParameter" DataSetColumn="TypeOfParameter" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypeOfProductsTableAdapter" GeneratorDataComponentClassName="TypeOfProductsTableAdapter" Name="TypeOfProducts" UserDataComponentName="TypeOfProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.TypeOfProducts" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TypeOfProducts] WHERE (([ID_TypeOfProduct] = @Original_ID_TypeOfProduct) AND ([TypeOfProduct] = @Original_TypeOfProduct))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeOfProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypeOfProducts] ([TypeOfProduct]) VALUES (@TypeOfProduct);
SELECT ID_TypeOfProduct, TypeOfProduct FROM TypeOfProducts WHERE (ID_TypeOfProduct = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeOfProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_TypeOfProduct, TypeOfProduct FROM dbo.TypeOfProducts</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypeOfProducts] SET [TypeOfProduct] = @TypeOfProduct WHERE (([ID_TypeOfProduct] = @Original_ID_TypeOfProduct) AND ([TypeOfProduct] = @Original_TypeOfProduct));
SELECT ID_TypeOfProduct, TypeOfProduct FROM TypeOfProducts WHERE (ID_TypeOfProduct = @ID_TypeOfProduct)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeOfProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeOfProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_TypeOfProduct" ColumnName="ID_TypeOfProduct" DataSourceName="dbQP.dbo.TypeOfProducts" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_TypeOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_TypeOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_TypeOfProduct" DataSetColumn="ID_TypeOfProduct" />
              <Mapping SourceColumn="TypeOfProduct" DataSetColumn="TypeOfProduct" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnitTableAdapter" GeneratorDataComponentClassName="UnitTableAdapter" Name="Unit" UserDataComponentName="UnitTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.Unit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Unit] WHERE (([ID_Unit] = @Original_ID_Unit) AND ([UnitName] = @Original_UnitName) AND ((@IsNull_UnitFullName = 1 AND [UnitFullName] IS NULL) OR ([UnitFullName] = @Original_UnitFullName)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UnitName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UnitFullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitFullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UnitFullName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitFullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Unit] ([UnitName], [UnitFullName]) VALUES (@UnitName, @UnitFullName);
SELECT ID_Unit, UnitName, UnitFullName FROM Unit WHERE (ID_Unit = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UnitName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UnitFullName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitFullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Unit, UnitName, UnitFullName FROM dbo.Unit</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Unit] SET [UnitName] = @UnitName, [UnitFullName] = @UnitFullName WHERE (([ID_Unit] = @Original_ID_Unit) AND ([UnitName] = @Original_UnitName) AND ((@IsNull_UnitFullName = 1 AND [UnitFullName] IS NULL) OR ([UnitFullName] = @Original_UnitFullName)));
SELECT ID_Unit, UnitName, UnitFullName FROM Unit WHERE (ID_Unit = @ID_Unit)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UnitName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UnitFullName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitFullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UnitName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UnitFullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitFullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UnitFullName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UnitFullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Unit" ColumnName="ID_Unit" DataSourceName="dbQP.dbo.Unit" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Unit" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Unit" DataSetColumn="ID_Unit" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="UnitFullName" DataSetColumn="UnitFullName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BatchesFullTableAdapter" GeneratorDataComponentClassName="BatchesFullTableAdapter" Name="BatchesFull" UserDataComponentName="BatchesFullTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DB (Settings)" DbObjectName="dbQP.dbo.BatchesFull" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, [Дата изготовления], [Номер партии], [Наименование продукции], Упаковка, Количество, [Единица измерения], Мастер, [Вид продукции] FROM dbo.BatchesFull</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Дата изготовления" DataSetColumn="Дата изготовления" />
              <Mapping SourceColumn="Номер партии" DataSetColumn="Номер партии" />
              <Mapping SourceColumn="Наименование продукции" DataSetColumn="Наименование продукции" />
              <Mapping SourceColumn="Упаковка" DataSetColumn="Упаковка" />
              <Mapping SourceColumn="Количество" DataSetColumn="Количество" />
              <Mapping SourceColumn="Единица измерения" DataSetColumn="Единица измерения" />
              <Mapping SourceColumn="Мастер" DataSetColumn="Мастер" />
              <Mapping SourceColumn="Вид продукции" DataSetColumn="Вид продукции" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dbQPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dbQPDataSet" msprop:Generator_UserDSName="dbQPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Batches" msprop:Generator_TableClassName="BatchesDataTable" msprop:Generator_TableVarName="tableBatches" msprop:Generator_TablePropName="Batches" msprop:Generator_RowDeletingName="BatchesRowDeleting" msprop:Generator_UserTableName="Batches" msprop:Generator_RowChangingName="BatchesRowChanging" msprop:Generator_RowEvHandlerName="BatchesRowChangeEventHandler" msprop:Generator_RowDeletedName="BatchesRowDeleted" msprop:Generator_RowEvArgName="BatchesRowChangeEvent" msprop:Generator_RowChangedName="BatchesRowChanged" msprop:Generator_RowClassName="BatchesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Batch" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Batch" msprop:Generator_ColumnPropNameInRow="ID_Batch" msprop:Generator_ColumnPropNameInTable="ID_BatchColumn" msprop:Generator_UserColumnName="ID_Batch" type="xs:int" />
              <xs:element name="BatchNumber" msprop:Generator_ColumnVarNameInTable="columnBatchNumber" msprop:Generator_ColumnPropNameInRow="BatchNumber" msprop:Generator_ColumnPropNameInTable="BatchNumberColumn" msprop:Generator_UserColumnName="BatchNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName" type="xs:int" />
              <xs:element name="DateOfManufacture" msprop:Generator_ColumnVarNameInTable="columnDateOfManufacture" msprop:Generator_ColumnPropNameInRow="DateOfManufacture" msprop:Generator_ColumnPropNameInTable="DateOfManufactureColumn" msprop:Generator_UserColumnName="DateOfManufacture" type="xs:dateTime" />
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:decimal" />
              <xs:element name="TypeOfPackaging" msprop:Generator_ColumnVarNameInTable="columnTypeOfPackaging" msprop:Generator_ColumnPropNameInRow="TypeOfPackaging" msprop:Generator_ColumnPropNameInTable="TypeOfPackagingColumn" msprop:Generator_UserColumnName="TypeOfPackaging" type="xs:int" />
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit" type="xs:int" />
              <xs:element name="Foreman" msprop:Generator_ColumnVarNameInTable="columnForeman" msprop:Generator_ColumnPropNameInRow="Foreman" msprop:Generator_ColumnPropNameInTable="ForemanColumn" msprop:Generator_UserColumnName="Foreman" type="xs:int" minOccurs="0" />
              <xs:element name="Analyst" msprop:Generator_ColumnVarNameInTable="columnAnalyst" msprop:Generator_ColumnPropNameInRow="Analyst" msprop:Generator_ColumnPropNameInTable="AnalystColumn" msprop:Generator_UserColumnName="Analyst" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Employees" msprop:Generator_TableClassName="EmployeesDataTable" msprop:Generator_TableVarName="tableEmployees" msprop:Generator_TablePropName="Employees" msprop:Generator_RowDeletingName="EmployeesRowDeleting" msprop:Generator_UserTableName="Employees" msprop:Generator_RowChangingName="EmployeesRowChanging" msprop:Generator_RowEvHandlerName="EmployeesRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeesRowDeleted" msprop:Generator_RowEvArgName="EmployeesRowChangeEvent" msprop:Generator_RowChangedName="EmployeesRowChanged" msprop:Generator_RowClassName="EmployeesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Employee" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Employee" msprop:Generator_ColumnPropNameInRow="ID_Employee" msprop:Generator_ColumnPropNameInTable="ID_EmployeeColumn" msprop:Generator_UserColumnName="ID_Employee" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Manufacturers" msprop:Generator_TableClassName="ManufacturersDataTable" msprop:Generator_TableVarName="tableManufacturers" msprop:Generator_TablePropName="Manufacturers" msprop:Generator_RowDeletingName="ManufacturersRowDeleting" msprop:Generator_UserTableName="Manufacturers" msprop:Generator_RowChangingName="ManufacturersRowChanging" msprop:Generator_RowEvHandlerName="ManufacturersRowChangeEventHandler" msprop:Generator_RowDeletedName="ManufacturersRowDeleted" msprop:Generator_RowEvArgName="ManufacturersRowChangeEvent" msprop:Generator_RowChangedName="ManufacturersRowChanged" msprop:Generator_RowClassName="ManufacturersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Taxpayer" msprop:Generator_ColumnVarNameInTable="columnID_Taxpayer" msprop:Generator_ColumnPropNameInRow="ID_Taxpayer" msprop:Generator_ColumnPropNameInTable="ID_TaxpayerColumn" msprop:Generator_UserColumnName="ID_Taxpayer" type="xs:int" />
              <xs:element name="ManufacturerName" msprop:Generator_ColumnVarNameInTable="columnManufacturerName" msprop:Generator_ColumnPropNameInRow="ManufacturerName" msprop:Generator_ColumnPropNameInTable="ManufacturerNameColumn" msprop:Generator_UserColumnName="ManufacturerName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LegalStatus" msprop:Generator_ColumnVarNameInTable="columnLegalStatus" msprop:Generator_ColumnPropNameInRow="LegalStatus" msprop:Generator_ColumnPropNameInTable="LegalStatusColumn" msprop:Generator_UserColumnName="LegalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LegalStatusFull" msprop:Generator_ColumnVarNameInTable="columnLegalStatusFull" msprop:Generator_ColumnPropNameInRow="LegalStatusFull" msprop:Generator_ColumnPropNameInTable="LegalStatusFullColumn" msprop:Generator_UserColumnName="LegalStatusFull" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Account" msprop:Generator_ColumnVarNameInTable="columnAccount" msprop:Generator_ColumnPropNameInRow="Account" msprop:Generator_ColumnPropNameInTable="AccountColumn" msprop:Generator_UserColumnName="Account" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="13" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bank" msprop:Generator_ColumnVarNameInTable="columnBank" msprop:Generator_ColumnPropNameInRow="Bank" msprop:Generator_ColumnPropNameInTable="BankColumn" msprop:Generator_UserColumnName="Bank" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankCode" msprop:Generator_ColumnVarNameInTable="columnBankCode" msprop:Generator_ColumnPropNameInRow="BankCode" msprop:Generator_ColumnPropNameInTable="BankCodeColumn" msprop:Generator_UserColumnName="BankCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Packaging" msprop:Generator_TableClassName="PackagingDataTable" msprop:Generator_TableVarName="tablePackaging" msprop:Generator_TablePropName="Packaging" msprop:Generator_RowDeletingName="PackagingRowDeleting" msprop:Generator_UserTableName="Packaging" msprop:Generator_RowChangingName="PackagingRowChanging" msprop:Generator_RowEvHandlerName="PackagingRowChangeEventHandler" msprop:Generator_RowDeletedName="PackagingRowDeleted" msprop:Generator_RowEvArgName="PackagingRowChangeEvent" msprop:Generator_RowChangedName="PackagingRowChanged" msprop:Generator_RowClassName="PackagingRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Packaging" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Packaging" msprop:Generator_ColumnPropNameInRow="ID_Packaging" msprop:Generator_ColumnPropNameInTable="ID_PackagingColumn" msprop:Generator_UserColumnName="ID_Packaging" type="xs:int" />
              <xs:element name="PackagingName" msprop:Generator_ColumnVarNameInTable="columnPackagingName" msprop:Generator_ColumnPropNameInRow="PackagingName" msprop:Generator_ColumnPropNameInTable="PackagingNameColumn" msprop:Generator_UserColumnName="PackagingName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Parameters" msprop:Generator_TableClassName="ParametersDataTable" msprop:Generator_TableVarName="tableParameters" msprop:Generator_TablePropName="Parameters" msprop:Generator_RowDeletingName="ParametersRowDeleting" msprop:Generator_UserTableName="Parameters" msprop:Generator_RowChangingName="ParametersRowChanging" msprop:Generator_RowEvHandlerName="ParametersRowChangeEventHandler" msprop:Generator_RowDeletedName="ParametersRowDeleted" msprop:Generator_RowEvArgName="ParametersRowChangeEvent" msprop:Generator_RowChangedName="ParametersRowChanged" msprop:Generator_RowClassName="ParametersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Parameter" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Parameter" msprop:Generator_ColumnPropNameInRow="ID_Parameter" msprop:Generator_ColumnPropNameInTable="ID_ParameterColumn" msprop:Generator_UserColumnName="ID_Parameter" type="xs:int" />
              <xs:element name="Parameter" msprop:Generator_ColumnVarNameInTable="columnParameter" msprop:Generator_ColumnPropNameInRow="Parameter" msprop:Generator_ColumnPropNameInTable="ParameterColumn" msprop:Generator_UserColumnName="Parameter" type="xs:int" />
              <xs:element name="Product" msprop:Generator_ColumnVarNameInTable="columnProduct" msprop:Generator_ColumnPropNameInRow="Product" msprop:Generator_ColumnPropNameInTable="ProductColumn" msprop:Generator_UserColumnName="Product" type="xs:int" />
              <xs:element name="Requirements" msprop:Generator_ColumnVarNameInTable="columnRequirements" msprop:Generator_ColumnPropNameInRow="Requirements" msprop:Generator_ColumnPropNameInTable="RequirementsColumn" msprop:Generator_UserColumnName="Requirements" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Products" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_TablePropName="Products" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_UserTableName="Products" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Product" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Product" msprop:Generator_ColumnPropNameInRow="ID_Product" msprop:Generator_ColumnPropNameInTable="ID_ProductColumn" msprop:Generator_UserColumnName="ID_Product" type="xs:int" />
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Manufacturer" msprop:Generator_ColumnVarNameInTable="columnManufacturer" msprop:Generator_ColumnPropNameInRow="Manufacturer" msprop:Generator_ColumnPropNameInTable="ManufacturerColumn" msprop:Generator_UserColumnName="Manufacturer" type="xs:int" />
              <xs:element name="TypeOfProduct" msprop:Generator_ColumnVarNameInTable="columnTypeOfProduct" msprop:Generator_ColumnPropNameInRow="TypeOfProduct" msprop:Generator_ColumnPropNameInTable="TypeOfProductColumn" msprop:Generator_UserColumnName="TypeOfProduct" type="xs:int" />
              <xs:element name="TechnicalStandards" msprop:Generator_ColumnVarNameInTable="columnTechnicalStandards" msprop:Generator_ColumnPropNameInRow="TechnicalStandards" msprop:Generator_ColumnPropNameInTable="TechnicalStandardsColumn" msprop:Generator_UserColumnName="TechnicalStandards">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="24" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Composition" msprop:Generator_ColumnVarNameInTable="columnComposition" msprop:Generator_ColumnPropNameInRow="Composition" msprop:Generator_ColumnPropNameInTable="CompositionColumn" msprop:Generator_UserColumnName="Composition">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="24" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExpirationDate" msprop:Generator_ColumnVarNameInTable="columnExpirationDate" msprop:Generator_ColumnPropNameInRow="ExpirationDate" msprop:Generator_ColumnPropNameInTable="ExpirationDateColumn" msprop:Generator_UserColumnName="ExpirationDate">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SignOfDanger" msprop:Generator_ColumnVarNameInTable="columnSignOfDanger" msprop:Generator_ColumnPropNameInRow="SignOfDanger" msprop:Generator_ColumnPropNameInTable="SignOfDangerColumn" msprop:Generator_UserColumnName="SignOfDanger" type="xs:boolean" />
              <xs:element name="DangerClass" msprop:Generator_ColumnVarNameInTable="columnDangerClass" msprop:Generator_ColumnPropNameInRow="DangerClass" msprop:Generator_ColumnPropNameInTable="DangerClassColumn" msprop:Generator_UserColumnName="DangerClass" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QualityPassports" msprop:Generator_TableClassName="QualityPassportsDataTable" msprop:Generator_TableVarName="tableQualityPassports" msprop:Generator_TablePropName="QualityPassports" msprop:Generator_RowDeletingName="QualityPassportsRowDeleting" msprop:Generator_UserTableName="QualityPassports" msprop:Generator_RowChangingName="QualityPassportsRowChanging" msprop:Generator_RowEvHandlerName="QualityPassportsRowChangeEventHandler" msprop:Generator_RowDeletedName="QualityPassportsRowDeleted" msprop:Generator_RowEvArgName="QualityPassportsRowChangeEvent" msprop:Generator_RowChangedName="QualityPassportsRowChanged" msprop:Generator_RowClassName="QualityPassportsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_QualityPassport" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_QualityPassport" msprop:Generator_ColumnPropNameInRow="ID_QualityPassport" msprop:Generator_ColumnPropNameInTable="ID_QualityPassportColumn" msprop:Generator_UserColumnName="ID_QualityPassport" type="xs:int" />
              <xs:element name="Parameter" msprop:Generator_ColumnVarNameInTable="columnParameter" msprop:Generator_ColumnPropNameInRow="Parameter" msprop:Generator_ColumnPropNameInTable="ParameterColumn" msprop:Generator_UserColumnName="Parameter" type="xs:int" minOccurs="0" />
              <xs:element name="MeasurementКesults" msprop:Generator_ColumnVarNameInTable="columnMeasurementКesults" msprop:Generator_ColumnPropNameInRow="MeasurementКesults" msprop:Generator_ColumnPropNameInTable="MeasurementКesultsColumn" msprop:Generator_UserColumnName="MeasurementКesults" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Batch" msprop:Generator_ColumnVarNameInTable="columnBatch" msprop:Generator_ColumnPropNameInRow="Batch" msprop:Generator_ColumnPropNameInTable="BatchColumn" msprop:Generator_UserColumnName="Batch" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TypeOfParameters" msprop:Generator_TableClassName="TypeOfParametersDataTable" msprop:Generator_TableVarName="tableTypeOfParameters" msprop:Generator_TablePropName="TypeOfParameters" msprop:Generator_RowDeletingName="TypeOfParametersRowDeleting" msprop:Generator_UserTableName="TypeOfParameters" msprop:Generator_RowChangingName="TypeOfParametersRowChanging" msprop:Generator_RowEvHandlerName="TypeOfParametersRowChangeEventHandler" msprop:Generator_RowDeletedName="TypeOfParametersRowDeleted" msprop:Generator_RowEvArgName="TypeOfParametersRowChangeEvent" msprop:Generator_RowChangedName="TypeOfParametersRowChanged" msprop:Generator_RowClassName="TypeOfParametersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_TypeOfParameter" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_TypeOfParameter" msprop:Generator_ColumnPropNameInRow="ID_TypeOfParameter" msprop:Generator_ColumnPropNameInTable="ID_TypeOfParameterColumn" msprop:Generator_UserColumnName="ID_TypeOfParameter" type="xs:int" />
              <xs:element name="TypeOfParameter" msprop:Generator_ColumnVarNameInTable="columnTypeOfParameter" msprop:Generator_ColumnPropNameInRow="TypeOfParameter" msprop:Generator_ColumnPropNameInTable="TypeOfParameterColumn" msprop:Generator_UserColumnName="TypeOfParameter">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TypeOfProducts" msprop:Generator_TableClassName="TypeOfProductsDataTable" msprop:Generator_TableVarName="tableTypeOfProducts" msprop:Generator_TablePropName="TypeOfProducts" msprop:Generator_RowDeletingName="TypeOfProductsRowDeleting" msprop:Generator_UserTableName="TypeOfProducts" msprop:Generator_RowChangingName="TypeOfProductsRowChanging" msprop:Generator_RowEvHandlerName="TypeOfProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="TypeOfProductsRowDeleted" msprop:Generator_RowEvArgName="TypeOfProductsRowChangeEvent" msprop:Generator_RowChangedName="TypeOfProductsRowChanged" msprop:Generator_RowClassName="TypeOfProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_TypeOfProduct" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_TypeOfProduct" msprop:Generator_ColumnPropNameInRow="ID_TypeOfProduct" msprop:Generator_ColumnPropNameInTable="ID_TypeOfProductColumn" msprop:Generator_UserColumnName="ID_TypeOfProduct" type="xs:int" />
              <xs:element name="TypeOfProduct" msprop:Generator_ColumnVarNameInTable="columnTypeOfProduct" msprop:Generator_ColumnPropNameInRow="TypeOfProduct" msprop:Generator_ColumnPropNameInTable="TypeOfProductColumn" msprop:Generator_UserColumnName="TypeOfProduct">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Unit" msprop:Generator_TableClassName="UnitDataTable" msprop:Generator_TableVarName="tableUnit" msprop:Generator_TablePropName="Unit" msprop:Generator_RowDeletingName="UnitRowDeleting" msprop:Generator_UserTableName="Unit" msprop:Generator_RowChangingName="UnitRowChanging" msprop:Generator_RowEvHandlerName="UnitRowChangeEventHandler" msprop:Generator_RowDeletedName="UnitRowDeleted" msprop:Generator_RowEvArgName="UnitRowChangeEvent" msprop:Generator_RowChangedName="UnitRowChanged" msprop:Generator_RowClassName="UnitRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Unit" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Unit" msprop:Generator_ColumnPropNameInRow="ID_Unit" msprop:Generator_ColumnPropNameInTable="ID_UnitColumn" msprop:Generator_UserColumnName="ID_Unit" type="xs:int" />
              <xs:element name="UnitName" msprop:Generator_ColumnVarNameInTable="columnUnitName" msprop:Generator_ColumnPropNameInRow="UnitName" msprop:Generator_ColumnPropNameInTable="UnitNameColumn" msprop:Generator_UserColumnName="UnitName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitFullName" msprop:Generator_ColumnVarNameInTable="columnUnitFullName" msprop:Generator_ColumnPropNameInRow="UnitFullName" msprop:Generator_ColumnPropNameInTable="UnitFullNameColumn" msprop:Generator_UserColumnName="UnitFullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BatchesFull" msprop:Generator_TableClassName="BatchesFullDataTable" msprop:Generator_TableVarName="tableBatchesFull" msprop:Generator_TablePropName="BatchesFull" msprop:Generator_RowDeletingName="BatchesFullRowDeleting" msprop:Generator_UserTableName="BatchesFull" msprop:Generator_RowChangingName="BatchesFullRowChanging" msprop:Generator_RowEvHandlerName="BatchesFullRowChangeEventHandler" msprop:Generator_RowDeletedName="BatchesFullRowDeleted" msprop:Generator_RowEvArgName="BatchesFullRowChangeEvent" msprop:Generator_RowChangedName="BatchesFullRowChanged" msprop:Generator_RowClassName="BatchesFullRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Дата_x0020_изготовления" msprop:Generator_ColumnVarNameInTable="columnДата_изготовления" msprop:Generator_ColumnPropNameInRow="Дата_изготовления" msprop:Generator_ColumnPropNameInTable="Дата_изготовленияColumn" msprop:Generator_UserColumnName="Дата изготовления" type="xs:dateTime" />
              <xs:element name="Номер_x0020_партии" msprop:Generator_ColumnVarNameInTable="columnНомер_партии" msprop:Generator_ColumnPropNameInRow="Номер_партии" msprop:Generator_ColumnPropNameInTable="Номер_партииColumn" msprop:Generator_UserColumnName="Номер партии">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Наименование_x0020_продукции" msprop:Generator_ColumnVarNameInTable="columnНаименование_продукции" msprop:Generator_ColumnPropNameInRow="Наименование_продукции" msprop:Generator_ColumnPropNameInTable="Наименование_продукцииColumn" msprop:Generator_UserColumnName="Наименование продукции">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Упаковка" msprop:Generator_ColumnVarNameInTable="columnУпаковка" msprop:Generator_ColumnPropNameInRow="Упаковка" msprop:Generator_ColumnPropNameInTable="УпаковкаColumn" msprop:Generator_UserColumnName="Упаковка">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Количество" msprop:Generator_ColumnVarNameInTable="columnКоличество" msprop:Generator_ColumnPropNameInRow="Количество" msprop:Generator_ColumnPropNameInTable="КоличествоColumn" msprop:Generator_UserColumnName="Количество" type="xs:decimal" />
              <xs:element name="Единица_x0020_измерения" msprop:Generator_ColumnVarNameInTable="columnЕдиница_измерения" msprop:Generator_ColumnPropNameInRow="Единица_измерения" msprop:Generator_ColumnPropNameInTable="Единица_измеренияColumn" msprop:Generator_UserColumnName="Единица измерения">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Мастер" msprop:Generator_ColumnVarNameInTable="columnМастер" msprop:Generator_ColumnPropNameInRow="Мастер" msprop:Generator_ColumnPropNameInTable="МастерColumn" msprop:Generator_UserColumnName="Мастер" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Вид_x0020_продукции" msprop:Generator_ColumnVarNameInTable="columnВид_продукции" msprop:Generator_ColumnPropNameInRow="Вид_продукции" msprop:Generator_ColumnPropNameInTable="Вид_продукцииColumn" msprop:Generator_UserColumnName="Вид продукции">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Batches" />
      <xs:field xpath="mstns:ID_Batch" />
    </xs:unique>
    <xs:unique name="Employees_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employees" />
      <xs:field xpath="mstns:ID_Employee" />
    </xs:unique>
    <xs:unique name="Manufacturers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Manufacturers" />
      <xs:field xpath="mstns:ID_Taxpayer" />
    </xs:unique>
    <xs:unique name="Packaging_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Packaging" />
      <xs:field xpath="mstns:ID_Packaging" />
    </xs:unique>
    <xs:unique name="Parameters_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Parameters" />
      <xs:field xpath="mstns:ID_Parameter" />
    </xs:unique>
    <xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Products" />
      <xs:field xpath="mstns:ID_Product" />
    </xs:unique>
    <xs:unique name="QualityPassports_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QualityPassports" />
      <xs:field xpath="mstns:ID_QualityPassport" />
    </xs:unique>
    <xs:unique name="TypeOfParameters_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TypeOfParameters" />
      <xs:field xpath="mstns:ID_TypeOfParameter" />
    </xs:unique>
    <xs:unique name="TypeOfProducts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TypeOfProducts" />
      <xs:field xpath="mstns:ID_TypeOfProduct" />
    </xs:unique>
    <xs:unique name="Unit_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Unit" />
      <xs:field xpath="mstns:ID_Unit" />
    </xs:unique>
    <xs:unique name="BatchesFull_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BatchesFull" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="Партии_FK00" msdata:parent="Products" msdata:child="Batches" msdata:parentkey="ID_Product" msdata:childkey="ProductName" msprop:Generator_UserChildTable="Batches" msprop:Generator_ChildPropName="GetBatchesRows" msprop:Generator_ParentPropName="ProductsRow" msprop:Generator_UserRelationName="Партии_FK00" msprop:Generator_RelationVarName="relationПартии_FK00" msprop:Generator_UserParentTable="Products" />
      <msdata:Relationship name="Партии_FK01" msdata:parent="Employees" msdata:child="Batches" msdata:parentkey="ID_Employee" msdata:childkey="Foreman" msprop:Generator_UserChildTable="Batches" msprop:Generator_ChildPropName="GetBatchesRowsByПартии_FK01" msprop:Generator_ParentPropName="EmployeesRowByПартии_FK01" msprop:Generator_UserRelationName="Партии_FK01" msprop:Generator_RelationVarName="relationПартии_FK01" msprop:Generator_UserParentTable="Employees" />
      <msdata:Relationship name="Партии_FK02" msdata:parent="Employees" msdata:child="Batches" msdata:parentkey="ID_Employee" msdata:childkey="Analyst" msprop:Generator_UserChildTable="Batches" msprop:Generator_ChildPropName="GetBatchesRowsByПартии_FK02" msprop:Generator_ParentPropName="EmployeesRowByПартии_FK02" msprop:Generator_UserRelationName="Партии_FK02" msprop:Generator_RelationVarName="relationПартии_FK02" msprop:Generator_UserParentTable="Employees" />
      <msdata:Relationship name="Партии_FK03" msdata:parent="Packaging" msdata:child="Batches" msdata:parentkey="ID_Packaging" msdata:childkey="TypeOfPackaging" msprop:Generator_UserChildTable="Batches" msprop:Generator_ChildPropName="GetBatchesRows" msprop:Generator_ParentPropName="PackagingRow" msprop:Generator_UserRelationName="Партии_FK03" msprop:Generator_RelationVarName="relationПартии_FK03" msprop:Generator_UserParentTable="Packaging" />
      <msdata:Relationship name="Партии_FK04" msdata:parent="Unit" msdata:child="Batches" msdata:parentkey="ID_Unit" msdata:childkey="Unit" msprop:Generator_UserChildTable="Batches" msprop:Generator_ChildPropName="GetBatchesRows" msprop:Generator_ParentPropName="UnitRow" msprop:Generator_UserRelationName="Партии_FK04" msprop:Generator_RelationVarName="relationПартии_FK04" msprop:Generator_UserParentTable="Unit" />
      <msdata:Relationship name="Показатели_FK00" msdata:parent="TypeOfParameters" msdata:child="Parameters" msdata:parentkey="ID_TypeOfParameter" msdata:childkey="Parameter" msprop:Generator_UserChildTable="Parameters" msprop:Generator_ChildPropName="GetParametersRows" msprop:Generator_ParentPropName="TypeOfParametersRow" msprop:Generator_UserRelationName="Показатели_FK00" msprop:Generator_RelationVarName="relationПоказатели_FK00" msprop:Generator_UserParentTable="TypeOfParameters" />
      <msdata:Relationship name="Показатели_FK01" msdata:parent="Products" msdata:child="Parameters" msdata:parentkey="ID_Product" msdata:childkey="Product" msprop:Generator_UserChildTable="Parameters" msprop:Generator_ChildPropName="GetParametersRows" msprop:Generator_ParentPropName="ProductsRow" msprop:Generator_UserRelationName="Показатели_FK01" msprop:Generator_RelationVarName="relationПоказатели_FK01" msprop:Generator_UserParentTable="Products" />
      <msdata:Relationship name="Продукция_FK00" msdata:parent="TypeOfProducts" msdata:child="Products" msdata:parentkey="ID_TypeOfProduct" msdata:childkey="TypeOfProduct" msprop:Generator_UserChildTable="Products" msprop:Generator_ChildPropName="GetProductsRows" msprop:Generator_ParentPropName="TypeOfProductsRow" msprop:Generator_UserRelationName="Продукция_FK00" msprop:Generator_RelationVarName="relationПродукция_FK00" msprop:Generator_UserParentTable="TypeOfProducts" />
      <msdata:Relationship name="Продукция_FK01" msdata:parent="Manufacturers" msdata:child="Products" msdata:parentkey="ID_Taxpayer" msdata:childkey="Manufacturer" msprop:Generator_UserChildTable="Products" msprop:Generator_ChildPropName="GetProductsRows" msprop:Generator_ParentPropName="ManufacturersRow" msprop:Generator_UserRelationName="Продукция_FK01" msprop:Generator_RelationVarName="relationПродукция_FK01" msprop:Generator_UserParentTable="Manufacturers" />
      <msdata:Relationship name="ПаспортКачества_FK00" msdata:parent="Batches" msdata:child="QualityPassports" msdata:parentkey="ID_Batch" msdata:childkey="Batch" msprop:Generator_UserChildTable="QualityPassports" msprop:Generator_ChildPropName="GetQualityPassportsRows" msprop:Generator_ParentPropName="BatchesRow" msprop:Generator_UserRelationName="ПаспортКачества_FK00" msprop:Generator_RelationVarName="relationПаспортКачества_FK00" msprop:Generator_UserParentTable="Batches" />
      <msdata:Relationship name="ПаспортКачества_FK01" msdata:parent="Parameters" msdata:child="QualityPassports" msdata:parentkey="ID_Parameter" msdata:childkey="Parameter" msprop:Generator_UserChildTable="QualityPassports" msprop:Generator_ChildPropName="GetQualityPassportsRows" msprop:Generator_ParentPropName="ParametersRow" msprop:Generator_UserRelationName="ПаспортКачества_FK01" msprop:Generator_RelationVarName="relationПаспортКачества_FK01" msprop:Generator_UserParentTable="Parameters" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>